package com.wanbangee.marksystem.service;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;

import com.wanbangee.marksystem.entities.StatisticsAverageRanking;
import com.wanbangee.marksystem.entities.StatisticsSubReport;

@Service
public interface StatistisGradeReportService {
	
	/**查询各科平均分/总分
	 * @param examId
	 * @return
	 */
	public List<StatisticsSubReport> selectAvgAndTotal(@Param("examId")Integer examId);
	
	/**查询统计各班级名称/人数/评分均/班主任/最高分/最低分
	 * @param examId
	 * @param subId
	 * @return
	 */
	public List<StatisticsAverageRanking> selectStatisticsAverageRankingByExamIdAndSubId(Integer examId, Integer subId);
	
	/**查询总平均分/满分/年级/班级数/人数
	 * @param examId
	 * @return
	 */
	public Map<String,Object> selectAvgAndTotalScoreByexamId(@Param("examId")Integer examId);
}
